﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetNaturalByIdCliente')
	BEGIN
		DROP  Procedure  GetNaturalByIdCliente
	END

GO

CREATE Procedure GetNaturalByIdCliente

	(
		@idCliente int
	)


AS

BEGIN
	SET NOCOUNT ON
	
	SELECT
	[Apellidos],
	[DNI],
	[IdCliente],
	[IdNatural],
	[Nombre]
	FROM [Natural] 
	WHERE [IdCliente] = @idCliente

	SET NOCOUNT OFF
END


GO


GRANT EXEC ON GetNaturalByIdCliente TO PUBLIC

GO


